Total Monthly Salary

After you have created a monthly salary, bonus, and merit formula, you can create a formula that adds all of those calculations together. This formula utilizes the IsNull block from the Functions tab which determines if there are blank values for a specific period in the calculated results from the monthly salary, bonus, and merit formulas. You can enter a 0 in the IsNull calculation to replace any blank values to make sure there is no impact to the overall calculation. For example, if a bonus calculation for a given month is $1000 and the IsNull function is used with a value of 0 for all other periods, the bonus calculation will remain at $1000. If you use a value of 1 in the IsNull calculation, then the bonus calculation for the year would be $1,011 (based on the 11 months carrying a 1 dollar value).

Totaly monthly salary selectable criteria

There are two different options for creating this formula:

  • Option 1: Select each formula block.

  • Option 2: Type the formula in the text field of the Text tab.

Option 1

Follow these instructions to create this formula by selecting each block:

  1. Populate the formula criteria:

    • Formula Name: Total Monthly Salary

    • (Optional) Formula Description

    • Register Group: All Employees

    • Value Type: Periodic

    • Account: 50299 - Monthly Total Salary

    • Scenario Type: All Scenarios

    • Periods: All periods selected

  2. Click the Functions tab and select the IsNull block.

  3. Select the vertical ellipses to the right of the IsNull block.

  4. Click the Accounts tab, select 50200 from the Account Name drop-down menu, select the Monthly Salary formula and click the Add Block button.

  5. Select the vertical ellipses after the next comma block.

  6. Click the Text tab, type 0 in the text field and click the Add To Formula button.

  7. Select the vertical ellipses after the next comma block.

  8. Click the + operator block.

  9. Click the Functions tab and select the IsNull block.

  10. Select the vertical ellipses to the right of the IsNull block.

  11. Click the Accounts tab, select 50220 from the Account Name drop-down menu, select the BonusCalc formula and click the Add Block button.

  12. Select the vertical ellipses after the next comma block.

  13. Click the Text tab, type 0 in the text field and click the Add To Formula button.

  14. Select the vertical ellipses after the next comma block.

  15. Click the + operator block.

  16. Click the Functions tab and select the IsNull block.

  17. Select the vertical ellipses to the right of the IsNull block.

  18. Click the Accounts tab, select 50250 from the Account Name drop-down menu, select the Merit Calc formula and click the Add Block button.

  19. Select the vertical ellipses after the next comma block.

  20. Click the Text tab, type 0 in the text field and click the Add To Formula button.

  21. Click the Save button. You will receive a confirmation message with the option to create another formula or return to the formula library.

Option 2

Follow these instructions to create this formula by typing the formula in the Text tab:

  1. Populate the formula criteria:

    • Formula Name: Total Monthly Salary

    • (Optional) Formula Description

    • Register Group: All Employees

    • Value Type: Periodic

    • Account: 50299 - Monthly Total Salary

    • Scenario Type: All Scenarios

    • Periods: All periods selected

  2. Click the Text tab, type IsNull(A#50200,0)+IsNull(A#50220,0)+IsNull(A#50250,0) in the text field and click the Add To Formula button.

  3. Click the Save button. You will receive a confirmation message with the option to create another formula or return to the formula library.